由 macro 发布于: 2001-03-04 15:03

What you should do before using logMiner

LogMiner runs in an oracle instance with the database either mounted or unmounted.LogMiner uses a dictionary file,which is a special file that indicates the database that created it as well as the time the file was created .The dictionary file is not required , but recommended.

Without a dictionary file ,the equivalent SQL statements will use an oracle internal object ID for the object name and present column values as hex data.

Creating a Dictionary File
1.Specify the initialization parameter UTL_FILE_DIR to specify a directory that is permitted for PL/SQL file I/O.
2.Execute the DBMS_LOGMNR_D.BUILD procedure to create the dicionary file.
__________________

谢谢你抽时间看我的发言，

Macro Zeng

==================================

我正在学习 Oracle ,坚持每天写读书笔记